<script>
function Del_Info(str){
	var q=confirm('Bạn có chắc chắn muốn xóa hay không?');	
	if(q==true) 
		window.location=str;
	
}
</script>
<?php
$sql="SELECT substr( QUYEN,9, 1 ) as mq
FROM qldl_tai_khoan
WHERE ten_dang_nhap = '".$_SESSION['username']."'";
	$query = @mysql_query($sql,$conn);
	$row = @mysql_fetch_array($query);
	if($row['mq']==1){
	 @header('Location: index.php?page=id_edit_cn&amp;id_edit_cn="'.$_GET['id_edit_cn'].'"'); 
	}
	else {
	echo  "<script>alert ('Bạn không có quyền truy cập trang này!')</script>"; 
	echo "<meta http-equiv='refresh' content='0;url= index.php'>";
	}
?>
<div class="cpanel-right-tttk">
  <div id="panel-sliders" class="pane-sliders">
    <div class="panel">
      <table width="100%" border="0" cellspacing="0" cellpadding="0" style=" padding:10px;">
        <thead>
        <tr style=" padding-bottom:10px;">
        <th colspan="3" align="left" style="padding-bottom:10px;">QUẢN LÍ CẨM NANG DU LỊCH</th>
        </tr> 
        </thead>
        
        <tr valign="top" style="padding:5px;">
          <td width="42%"><div style=" padding:0px; border-top: medium none; border-bottom: medium none; overflow: hidden; height: auto; width:100%" align="left">
            <table width="100%" border="1" bordercolor="#666666" class="adminlist_tt">
              <thead>
                <tr>
                  <th colspan="2"> Sửa cẩm nang du lịch</th>
                </tr>
   <?php  
if(isset($_POST['btn_edit_gt'])){ 
	$mscn = $_POST['txt_mscn'];
	$tlcn = $_POST['txt_tlcn'];
	$ndcn = $_POST['area'];

	if ($_FILES["file_up"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file_up"]["error"] . "<br />";
    }
  else
    { $link =$_FILES["file_up"]["name"];
    if (file_exists("camnang_dulich/upload/news/" . $_FILES["file_up"]["name"]))
      {
      echo $_FILES["file_up"]["name"] . " da ton tai file tren server. ";
      }
    else
      {  
      move_uploaded_file($_FILES["file_up"]["tmp_name"],
      "camnang_dulich/upload/news/" . $_FILES["file_up"]["name"]);	
	  
	   
      }
	}
	$sql1 = "update qldl_can_nan_du_lich set				
				THE_LOAI='$tlcn',
				NOI_DUNG='$ndcn',
				HINH_ANH='$link'
			where MA_SO='$mscn'
			";
	$query1 = @mysql_query($sql1,$conn);
	/////////////////////////////
	if($query1)echo "<script>alert ('Cập nhật thông tin thành công.')</script>";	
	else echo "<script>alert ('Lỗi cập nhật thông tin!')</script>";	
	echo  "<meta http-equiv='refresh' content='0;url=index.php?page=cn'>";
}
?>

              </thead>
              <tbody>
              <form action="" method="post" name="form_edit" id="form_edit" onsubmit="return input_edit();">
<?php  
	$sql="select * from qldl_cam_nan_du_lich where MA_SO='".$_GET['id_edit_cn']."'";
	$query = @mysql_query($sql,$conn);	
	if(!$query) echo "Query error to display.";
	else $row = @mysql_fetch_array($query);
		
  ?>
                <tr>
                  <td width="75">Mã số </td>
                  <td><label for="txt_mscn"></label>
                    <input type="text" name="txt_mscn" id="txt_mscn" width="180px" value="<?php echo $row['MA_SO'];?>" readonly="readonly" /></td>
                  </tr>
                <tr>
                  <td>Tiêu đề</td>
                  <td><input type="text" name="txt_tlcn" id="txt_tlcn" width="180px" value="<?php echo $row['TIEU_DE'];?>" /></td>
                  </tr>
                <tr>
                  <td>Nôi dụng</td>
                  <td><label for="textarea_ndcn"></label>
                    <textarea name="area" id="area" style="height:100px; width:100%;" value="<?php echo $row['NOI_DUNG'];?>"><?php echo $row['NOI_DUNG'];?></textarea></td>
                  </tr>
                <tr>
                  <td colspan="2"><input type="file" name="file_up" /></td>
                  </tr>
                <tr>
                  <td colspan="2"><input type="submit" name="btn_add_cn" id="btn_add_cn" value="Lưu" onclick='window.location.href="index.php?page=cn"' />
                    <input type="reset" name="btn_huy_cn" id="btn_huy_cn" value="Hủy" onclick='window.location.href="index.php?page=cn"' />
             
                    </td>
                </tr>
                </form>
              </tbody>
            </table>
          </div></td>
          <td width="12%">&nbsp;</td>
          <td width="46%"><div style=" padding:0px; border-top: medium none; border-bottom: medium none; overflow: hidden; height: auto; width:100%" align="left" >
            <table width="100%" border="1" bordercolor="#666666" class="adminlist_tt" >
              <thead>
                <tr>
                  <th colspan="4"> Danh sách cẩm nang du lịch</th>
                  <?php include('camnang_dulich/del.php'); ?>
                </tr>
              </thead>
              <tbody>
                <form action="" method="post" name="form_view" id="form_view">
                <tr>
                  <td width="51">Stt</td>
                  <td width="67">Mã số</td>
                  <td width="236">Thể loại</td>
                  <td width="130">Cập nhật</td>
                </tr>
                <?php  
	$stt=0;
	$sql="select * from qldl_cam_nan_du_lich";
	$query = @mysql_query($sql,$conn);	
	if(!$query) echo "Query error to display.";
	else while($row = @mysql_fetch_array($query)){
		$stt++;
		?>
                <tr>
                  <td><?php echo $stt;?></td>
                  <td><?php echo $row['MA_SO'];?></td>
                  <td><?php echo $row['TIEU_DE'];?></td>
                  <td><a href="index.php?page=id_edit_cn&amp;id_edit_cn=<?php echo $row['MA_SO'];?>">Sửa</a> || 
                  <a onclick="Del_Info('index.php?page=cn&amp;id_del_cn=<?php echo $row['MA_SO']; ?>');" href="#">Xóa</a></td>
                </tr>
                <?php }?>
                </form>
              </tbody>
            </table>
          </div></td>
        </tr>
      </table>
    </div>
  </div>
</div>
